TG: sql_for_qa/64

SQL для тестировщика

Какой из следующих SQL запросов вернет топ-5 самых просматриваемых постов из таблицы posts, отсортированных по количеству просмотров в порядке убывания?

Anonymous Quiz

SELECT * FROM posts ORDER BY views DESC LIMIT 5;

SELECT TOP 5 * FROM posts ORDER BY views DESC;

SELECT * FROM posts WHERE ROWNUM <= 5 ORDER BY views DESC;

SELECT * FROM posts WHERE views >= 5 ORDER BY views DESC LIMIT 5;

641 answered

www.tg-me.com/no/SQL для тестировщика/com.sql_for_qa/64

2.6K viewsMar 17, 2023 at 11:02

tg-me.com/sql_for_qa/64

Create: 2023-03-17
Last Update: 2025-07-03 01:16:56

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/64

SQL для тестировщика Telegram | DID YOU KNOW?

At a time when the Indian stock market is peaking and has rallied immensely compared to global markets, there are companies that have not performed in the last 10 years. These are definitely a minor portion of the market considering there are hundreds of stocks that have turned multibagger since 2020. What went wrong with these stocks? Reasons vary from corporate governance, sectoral weakness, company specific and so on. But the more important question is, are these stocks worth buying?